QuickOPC User's Guide and Reference
Introduction to Excel Option
With the Excel Option for QuickOPC, you can set up a communication link between Excel and any OPC server. It is possible to subscribe to and view real-time data, and also write the data back.
OPC Classic, OPC XML and OPC UA servers are supported. No programming, macros or add-ins are necessary.
The QuickOPC Excel Option supports following Excel versions:
Excel 2003 may also work, but we have not tested with it and do not officially support it.
Note that Excel 2003, Excel 2007 and Excel 2010 are no longer on mainstream support by Microsoft.
Excel Option is licensed separately from the base product, and in such case you will receive a separate license file for the Excel Option. See License Manager for more information.
The license is shown with Description "Excel Option". Its ID for use with the LMConsole Utility (License Manager Console) is "ExcelOption". When properly installed, you will have two licenses under the "QuickOPC" component name in License Manager, and the form will look similar to this:
If you are running the trial license, Excel Option is automatically included (enabled), with 30-minute runtime limitation per each process (Excel) run.
The licenses to any of the QuickOPC Product Options (such as Excel Option for QuickOPC) are always an addition to your base QuickOPC license. That is, to use any specific QuickOPC Product Option, you always need a QuickOPC license, and a license to that QuickOPC Product Option. Without the base QuickOPC license, the license for the QuickOPC Product Option is useless.
There is no specific Upgrade Assurance for QuickOPC Product Options. The Upgrade Assurance period of any QuickOPC Product Option follows the Upgrade Assurance period of the base QuickOPC license.
The trial license allows you to use QuickOPC together with all its Product Options. You do not need a specific trial license, if you want to try out any of the QuickOPC Product Options.